package com.sky.mapper;

import com.sky.entity.AddressBook;
import org.apache.ibatis.annotations.*;
import org.springframework.web.bind.annotation.DeleteMapping;

import java.util.List;

@Mapper
public interface addressMapper {
    @Select("select * from address_book where user_id=#{currentId}")
    List<AddressBook> selectByUserId(Long currentId);

    @Insert("insert into address_book (user_id, consignee, sex, phone, province_code," +
            " province_name, city_code, city_name, district_code, district_name," +
            " detail, label,is_default) VALUES (#{userId},#{consignee},#{sex},#{phone}" +
            ",#{provinceCode}," +
            "#{provinceName},#{cityCode},#{cityName},#{districtCode},#{districtName},#{detail}," +
            "#{label},#{isDefault}) ")
    void addNewAddress(AddressBook addressBook);

    @Select("select * from address_book where user_id=#{currentId} and is_default=1")
    AddressBook selectDefault(Long currentId);
    @Select("select * from  address_book where id=#{id}")
    AddressBook selectById(Integer id);


    void update(AddressBook addressBook);

    @Delete("delete  from address_book where id=#{id}")
    void delete(Integer id);


}
